Adding an SQL or ODBC data source

  1. While in the Crystal Dictionary Expert, click the Tables tab.

  2. Click the SQL/ODBC button.

    The Log On Server dialog box appears.

  3. Select an SQL or ODBC data source and click OK when finished.

    If the data source requires any log on information, such as user name and password, the SQL Server Login dialog box appears.

  4. Log on to the ODBC data source just as you normally do from your Database Management System application.
  5. Click OK.

    The Choose SQL Table dialog box appears.

  6. Highlight a database in the SQL Databases list box.

    The SQL Tables list box displays all of the tables for the database you selected.

  7. Highlight the table you would like to have included and click Add to add it to your dictionary.
  8. Repeat Step 7 for each table you want to add to the dictionary.
  9. Click Done when finished.

Note:    When an SQL or ODBC data source is added from the Tables Tab, the tables and fields from that data source will not necessarily appear to the user who opens the dictionary. The tables that appear on the Tables Tab are only the tables available to the creator of the dictionary, for adding to the dictionary. See Designing the view of the data.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com